﻿CREATE PROCEDURE [dbo].[Province_Select]
@ProvinceID uniqueidentifier
AS
BEGIN

SELECT [ProvinceID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [CountryID]
, [Description]
, [SystemDescription]
FROM [dbo].[Province] (NoLock)
WHERE [Deleted] = 0
AND [ProvinceID] = @ProvinceID


END
